Sort a Data Grid Using Multiple Columns
You can sort the rows in your data grid using the values in more than one column. The values are sorted by the first column you select. Then, when more than one row in the data grid has the same value in the first column, the rows are sorted by the second column you select. The values are sorted alphabetically or numerically, depending on the type of values in the column.
To sort by more than one column:
- Click the heading of the first column by which you want to sort.
- Hold CTRL and right-click the second column by which you want to sort.
- To sort in ascending order, click Sort Ascending. To sort in descending order, click Sort Descending.
- Continue holding CTRL, right-click each subsequent column by which you want to sort, and select Sort Ascending or Sort Descending.
- When you have finished sorting the rows of the data grid, release CTRL.
Note: You cannot sort all data grids by column values. For example, you cannot group the Material classes and Qualities data grids by column value. However, these data grids have arrow controls at the top of the data grid that you use to control the position of each row in the data grid.